This issue just happend today: when query a certain table, mysql returns error message: "MySQL said: Got error 127 from table handler". Only one table got such an problem. We never touched it before. Anyone have an idear? Thanks!
Alex
This might help: http://forums.devshed.com/t101141/s3f423285f17bf5511ffdd4f05753da55.html
I tried repair but got following error message:
"error The handler for the table doesn't support check/repair"
Alex
Hmm, have you tried using PhpMyAdmin to see if you can browse the records in the thing? Maybe PhpMyAdmin will be able to guide you to a solution...
PhpMyAdmin is reliant on Mod_php being installed and it well check and repair a table so maybe there is somethng that is installed when Mod_php is installed that handles the check and repair.
I tried PhpMyAdmin but no use. I placed an emergency ticket but nobody even reviewed it. I am thinking that the only way to resume it is to have westhost restore the table file from their backup tape - they do regular tape backup, do they?
Same problem in my case.:( It happened few days ago, and westhost I think restarted mysqld but now again. I also have a table what is unaccessable (status="in use" ). I don't know but this Sql server is a disaster, almost every day is a problem... I already lose data. Or is my script?! I used the same scripts on old westhost server, where never happend anything like this... Hopefully westhost will do something or I have to looking for an other host...
In my case the "repaire table" command (from phpMyAdmin) did the job, but unfortunately one of the table loose data...
Hi,
Once you get your database fixed up why not "dump" your database every so often just in case? I do this because of past issues with other services. I'm new to WestHost but do they let you set up CronJobs? There could be an answer there as well. I back up my entire website at least weekly and more if there is a lot of activity.
HTH,
Barb
You can also turn on the mysql logging and have a look in the logs to see if there are any strange error messages.
And, as Barb suggests, its easy to setup a cron job to backup the database on a regular basis.
HTH
You have right with backups, but when every day one or more of the tables get this error, something wrong with MySQL or with server . Now to be better I get this error : Too many connections.
I'm new to WestHost but do they let you set up CronJobs?
Yup...
editcron -e
(via SSH).
I think we got the solution for my problem. I checked mysql logs and there was a log about a problem loading the innoDB tables. After I reported for westhost, they did something because now after mysqld reboot the message is not there and it seams to works fine.